Overview
Brought to you by YData
Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 360336 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 54.8 MiB |
| Average record size in memory | 159.5 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 8 |
coffee_bar is highly overall correlated with florist and 2 other fields | High correlation |
florist is highly overall correlated with coffee_bar and 4 other fields | High correlation |
prepared_food is highly overall correlated with florist and 3 other fields | High correlation |
salad_bar is highly overall correlated with florist and 3 other fields | High correlation |
store_sqft is highly overall correlated with coffee_bar and 4 other fields | High correlation |
video_store is highly overall correlated with coffee_bar and 4 other fields | High correlation |
total_children has 36441 (10.1%) zeros | Zeros |
num_children_at_home has 243555 (67.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-14 09:28:02.382032 |
|---|---|
| Analysis finished | 2025-11-14 09:28:13.260642 |
| Duration | 10.88 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
store_sales(in millions)
Real number (ℝ)
| Distinct | 1044 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.3373763 |
| Minimum | 0.51 |
|---|---|
| Maximum | 22.92 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 13.6 MiB |
Quantile statistics
| Minimum | 0.51 |
|---|---|
| 5-th percentile | 1.78 |
| Q1 | 3.72 |
| median | 5.78 |
| Q3 | 8.4 |
| 95-th percentile | 11.91 |
| Maximum | 22.92 |
| Range | 22.41 |
| Interquartile range (IQR) | 4.68 |
Descriptive statistics
| Standard deviation | 3.3079796 |
|---|---|
| Coefficient of variation (CV) | 0.52197936 |
| Kurtosis | 0.075175055 |
| Mean | 6.3373763 |
| Median Absolute Deviation (MAD) | 2.26 |
| Skewness | 0.66149169 |
| Sum | 2283584.8 |
| Variance | 10.942729 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5.04 | 2373 | 0.7% |
| 5.4 | 1988 | 0.6% |
| 7.41 | 1919 | 0.5% |
| 7.95 | 1874 | 0.5% |
| 5.52 | 1831 | 0.5% |
| 4.8 | 1726 | 0.5% |
| 6.84 | 1716 | 0.5% |
| 2.28 | 1676 | 0.5% |
| 3.6 | 1651 | 0.5% |
| 6.72 | 1569 | 0.4% |
| Other values (1034) | 342013 |
| Value | Count | Frequency (%) |
| 0.51 | 4 | < 0.1% |
| 0.52 | 28 | |
| 0.53 | 20 | |
| 0.54 | 6 | < 0.1% |
| 0.55 | 13 | |
| 0.56 | 14 | |
| 0.57 | 24 | |
| 0.58 | 20 | |
| 0.6 | 28 | |
| 0.61 | 17 |
| Value | Count | Frequency (%) |
| 22.92 | 1 | < 0.1% |
| 22.16 | 1 | < 0.1% |
| 20.6 | 1 | < 0.1% |
| 20.14 | 1 | < 0.1% |
| 19.95 | 1 | < 0.1% |
| 19.9 | 18 | < 0.1% |
| 19.85 | 9 | < 0.1% |
| 19.8 | 8 | < 0.1% |
| 19.75 | 59 | |
| 19.7 | 14 | < 0.1% |
unit_sales(in millions)
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.0438813 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 13.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.78467595 |
|---|---|
| Coefficient of variation (CV) | 0.25778796 |
| Kurtosis | -0.25012041 |
| Mean | 3.0438813 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.10799835 |
| Sum | 1096820 |
| Variance | 0.61571635 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 3 | 175556 | |
| 4 | 94999 | |
| 2 | 77240 | |
| 1 | 6765 | 1.9% |
| 5 | 5745 | 1.6% |
| 6 | 31 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 6765 | 1.9% |
| 2 | 77240 | |
| 3 | 175556 | |
| 4 | 94999 | |
| 5 | 5745 | 1.6% |
| 6 | 31 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 31 | < 0.1% |
| 5 | 5745 | 1.6% |
| 4 | 94999 | |
| 3 | 175556 | |
| 2 | 77240 | |
| 1 | 6765 | 1.9% |
total_children
Real number (ℝ)
Zeros
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4564823 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 36441 |
| Zeros (%) | 10.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 13.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.4889919 |
|---|---|
| Coefficient of variation (CV) | 0.60614803 |
| Kurtosis | -1.0394866 |
| Mean | 2.4564823 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.035134467 |
| Sum | 885159 |
| Variance | 2.2170969 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 1 | 74857 | |
| 2 | 73902 | |
| 3 | 71524 | |
| 4 | 70134 | |
| 0 | 36441 | |
| 5 | 33478 |
| Value | Count | Frequency (%) |
| 0 | 36441 | |
| 1 | 74857 | |
| 2 | 73902 | |
| 3 | 71524 | |
| 4 | 70134 | |
| 5 | 33478 |
| Value | Count | Frequency (%) |
| 5 | 33478 | |
| 4 | 70134 | |
| 3 | 71524 | |
| 2 | 73902 | |
| 1 | 74857 | |
| 0 | 36441 |
num_children_at_home
Real number (ℝ)
Zeros
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6893899 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 243555 |
| Zeros (%) | 67.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 13.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.2147324 |
|---|---|
| Coefficient of variation (CV) | 1.7620398 |
| Kurtosis | 2.5983024 |
| Mean | 0.6893899 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.8486807 |
| Sum | 248412 |
| Variance | 1.4755749 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 243555 | |
| 1 | 49427 | 13.7% |
| 2 | 28163 | 7.8% |
| 3 | 20382 | 5.7% |
| 4 | 12532 | 3.5% |
| 5 | 6277 | 1.7% |
| Value | Count | Frequency (%) |
| 0 | 243555 | |
| 1 | 49427 | 13.7% |
| 2 | 28163 | 7.8% |
| 3 | 20382 | 5.7% |
| 4 | 12532 | 3.5% |
| 5 | 6277 | 1.7% |
| Value | Count | Frequency (%) |
| 5 | 6277 | 1.7% |
| 4 | 12532 | 3.5% |
| 3 | 20382 | 5.7% |
| 2 | 28163 | 7.8% |
| 1 | 49427 | 13.7% |
| 0 | 243555 |
avg_cars_at home(approx).1
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.6 MiB |
| 2.0 | |
|---|---|
| 3.0 | |
| 1.0 | |
| 4.0 | |
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 3.0 |
| 3rd row | 3.0 |
| 4th row | 0.0 |
| 5th row | 3.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 110401 | |
| 3.0 | 104424 | |
| 1.0 | 82619 | |
| 4.0 | 44355 | |
| 0.0 | 18537 | 5.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2.0 | 110401 | |
| 3.0 | 104424 | |
| 1.0 | 82619 | |
| 4.0 | 44355 | |
| 0.0 | 18537 | 5.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 378873 | |
| . | 360336 | |
| 2 | 110401 | 10.2% |
| 3 | 104424 | 9.7% |
| 1 | 82619 | 7.6% |
| 4 | 44355 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 378873 | |
| . | 360336 | |
| 2 | 110401 | 10.2% |
| 3 | 104424 | 9.7% |
| 1 | 82619 | 7.6% |
| 4 | 44355 | 4.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 378873 | |
| . | 360336 | |
| 2 | 110401 | 10.2% |
| 3 | 104424 | 9.7% |
| 1 | 82619 | 7.6% |
| 4 | 44355 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 378873 | |
| . | 360336 | |
| 2 | 110401 | 10.2% |
| 3 | 104424 | 9.7% |
| 1 | 82619 | 7.6% |
| 4 | 44355 | 4.1% |
gross_weight
Real number (ℝ)
| Distinct | 384 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.822071 |
| Minimum | 6 |
|---|---|
| Maximum | 21.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 13.6 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 6.98 |
| Q1 | 9.71 |
| median | 13.6 |
| Q3 | 17.7 |
| 95-th percentile | 21.2 |
| Maximum | 21.9 |
| Range | 15.9 |
| Interquartile range (IQR) | 7.99 |
Descriptive statistics
| Standard deviation | 4.6147921 |
|---|---|
| Coefficient of variation (CV) | 0.33387125 |
| Kurtosis | -1.2321255 |
| Mean | 13.822071 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.093304798 |
| Sum | 4980589.8 |
| Variance | 21.296306 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 17.1 | 4372 | 1.2% |
| 14.7 | 3906 | 1.1% |
| 19.9 | 3800 | 1.1% |
| 17.2 | 3616 | 1.0% |
| 13.7 | 3516 | 1.0% |
| 13.2 | 3431 | 1.0% |
| 18.7 | 3430 | 1.0% |
| 16.1 | 3397 | 0.9% |
| 20.9 | 3374 | 0.9% |
| 21.8 | 3248 | 0.9% |
| Other values (374) | 324246 |
| Value | Count | Frequency (%) |
| 6 | 210 | |
| 6.03 | 157 | < 0.1% |
| 6.04 | 166 | < 0.1% |
| 6.06 | 358 | |
| 6.09 | 198 | |
| 6.11 | 415 | |
| 6.12 | 226 | |
| 6.13 | 197 | |
| 6.14 | 395 | |
| 6.15 | 207 |
| Value | Count | Frequency (%) |
| 21.9 | 3106 | |
| 21.8 | 3248 | |
| 21.7 | 3130 | |
| 21.6 | 1724 | |
| 21.5 | 1926 | |
| 21.4 | 1868 | |
| 21.3 | 2721 | |
| 21.2 | 2837 | |
| 21.1 | 1556 | |
| 21 | 2537 |
recyclable_package
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.6 MiB |
| 1.0 | |
|---|---|
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 0.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 204702 | |
| 0.0 | 155634 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 204702 | |
| 0.0 | 155634 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 515970 | |
| . | 360336 | |
| 1 | 204702 | 18.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 515970 | |
| . | 360336 | |
| 1 | 204702 | 18.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 515970 | |
| . | 360336 | |
| 1 | 204702 | 18.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 515970 | |
| . | 360336 | |
| 1 | 204702 | 18.9% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 242219 | |
| 1.0 | 118117 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 242219 | |
| 1.0 | 118117 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 602555 | |
| . | 360336 | |
| 1 | 118117 | 10.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 602555 | |
| . | 360336 | |
| 1 | 118117 | 10.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 602555 | |
| . | 360336 | |
| 1 | 118117 | 10.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 602555 | |
| . | 360336 | |
| 1 | 118117 | 10.9% |
units_per_case
Real number (ℝ)
| Distinct | 36 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.972706 |
| Minimum | 1 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 13.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 10 |
| median | 20 |
| Q3 | 28 |
| 95-th percentile | 34 |
| Maximum | 36 |
| Range | 35 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 10.212912 |
|---|---|
| Coefficient of variation (CV) | 0.53829498 |
| Kurtosis | -1.2445497 |
| Mean | 18.972706 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -0.10200888 |
| Sum | 6836549 |
| Variance | 104.30358 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) |
| 29 | 14626 | 4.1% |
| 6 | 14064 | 3.9% |
| 33 | 13483 | 3.7% |
| 31 | 12947 | 3.6% |
| 30 | 12847 | 3.6% |
| 23 | 12517 | 3.5% |
| 26 | 12050 | 3.3% |
| 25 | 11651 | 3.2% |
| 5 | 11624 | 3.2% |
| 9 | 11219 | 3.1% |
| Other values (26) | 233308 |
| Value | Count | Frequency (%) |
| 1 | 5273 | 1.5% |
| 2 | 9195 | |
| 3 | 10736 | |
| 4 | 9194 | |
| 5 | 11624 | |
| 6 | 14064 | |
| 7 | 8367 | |
| 8 | 7928 | |
| 9 | 11219 | |
| 10 | 8217 |
| Value | Count | Frequency (%) |
| 36 | 4005 | 1.1% |
| 35 | 9203 | |
| 34 | 10401 | |
| 33 | 13483 | |
| 32 | 9668 | |
| 31 | 12947 | |
| 30 | 12847 | |
| 29 | 14626 | |
| 28 | 8960 | |
| 27 | 9697 |
store_sqft
Real number (ℝ)
High correlation
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28180.333 |
| Minimum | 20319 |
|---|---|
| Maximum | 39696 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 13.6 MiB |
Quantile statistics
| Minimum | 20319 |
|---|---|
| 5-th percentile | 20319 |
| Q1 | 23593 |
| median | 27694 |
| Q3 | 33858 |
| 95-th percentile | 39696 |
| Maximum | 39696 |
| Range | 19377 |
| Interquartile range (IQR) | 10265 |
Descriptive statistics
| Standard deviation | 5968.8741 |
|---|---|
| Coefficient of variation (CV) | 0.21180992 |
| Kurtosis | -1.0730401 |
| Mean | 28180.333 |
| Median Absolute Deviation (MAD) | 4582 |
| Skewness | 0.3926991 |
| Sum | 1.0154389 × 1010 |
| Variance | 35627458 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 21215 | 31807 | 8.8% |
| 27694 | 30280 | 8.4% |
| 33858 | 30218 | 8.4% |
| 23598 | 29659 | 8.2% |
| 20319 | 29193 | 8.1% |
| 30268 | 25995 | 7.2% |
| 30797 | 24271 | 6.7% |
| 39696 | 19690 | 5.5% |
| 23112 | 17765 | 4.9% |
| 34791 | 16498 | 4.6% |
| Other values (10) | 104960 |
| Value | Count | Frequency (%) |
| 20319 | 29193 | |
| 21215 | 31807 | |
| 22478 | 7314 | 2.0% |
| 23112 | 17765 | |
| 23593 | 11877 | 3.3% |
| 23598 | 29659 | |
| 23688 | 16072 | |
| 23759 | 14934 | |
| 24597 | 3486 | 1.0% |
| 27694 | 30280 |
| Value | Count | Frequency (%) |
| 39696 | 19690 | |
| 38382 | 16454 | |
| 36509 | 9701 | 2.7% |
| 34791 | 16498 | |
| 34452 | 5319 | 1.5% |
| 33858 | 30218 | |
| 30797 | 24271 | |
| 30584 | 13016 | |
| 30268 | 25995 | |
| 28206 | 6787 | 1.9% |
coffee_bar
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.6 MiB |
| 1.0 | |
|---|---|
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 203532 | |
| 0.0 | 156804 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 203532 | |
| 0.0 | 156804 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 517140 | |
| . | 360336 | |
| 1 | 203532 | 18.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 517140 | |
| . | 360336 | |
| 1 | 203532 | 18.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 517140 | |
| . | 360336 | |
| 1 | 203532 | 18.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 517140 | |
| . | 360336 | |
| 1 | 203532 | 18.8% |
video_store
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.6 MiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 260381 | |
| 1.0 | 99955 | 27.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 260381 | |
| 1.0 | 99955 | 27.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 620717 | |
| . | 360336 | |
| 1 | 99955 | 9.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 620717 | |
| . | 360336 | |
| 1 | 99955 | 9.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 620717 | |
| . | 360336 | |
| 1 | 99955 | 9.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 620717 | |
| . | 360336 | |
| 1 | 99955 | 9.2% |
salad_bar
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.6 MiB |
| 1.0 | |
|---|---|
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 181900 | |
| 0.0 | 178436 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 181900 | |
| 0.0 | 178436 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 538772 | |
| . | 360336 | |
| 1 | 181900 | 16.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 538772 | |
| . | 360336 | |
| 1 | 181900 | 16.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 538772 | |
| . | 360336 | |
| 1 | 181900 | 16.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 538772 | |
| . | 360336 | |
| 1 | 181900 | 16.8% |
prepared_food
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.6 MiB |
| 1.0 | |
|---|---|
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 181909 | |
| 0.0 | 178427 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 181909 | |
| 0.0 | 178427 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 538763 | |
| . | 360336 | |
| 1 | 181909 | 16.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 538763 | |
| . | 360336 | |
| 1 | 181909 | 16.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 538763 | |
| . | 360336 | |
| 1 | 181909 | 16.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 538763 | |
| . | 360336 | |
| 1 | 181909 | 16.8% |
florist
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.6 MiB |
| 1.0 | |
|---|---|
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 181318 | |
| 0.0 | 179018 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 181318 | |
| 0.0 | 179018 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 539354 | |
| . | 360336 | |
| 1 | 181318 | 16.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 539354 | |
| . | 360336 | |
| 1 | 181318 | 16.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 539354 | |
| . | 360336 | |
| 1 | 181318 | 16.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1081008 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 539354 | |
| . | 360336 | |
| 1 | 181318 | 16.8% |
cost
Real number (ℝ)
| Distinct | 328 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 99.614729 |
| Minimum | 50.79 |
|---|---|
| Maximum | 149.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 13.6 MiB |
Quantile statistics
| Minimum | 50.79 |
|---|---|
| 5-th percentile | 53.82 |
| Q1 | 70.32 |
| median | 98.81 |
| Q3 | 126.62 |
| 95-th percentile | 145.41 |
| Maximum | 149.75 |
| Range | 98.96 |
| Interquartile range (IQR) | 56.3 |
Descriptive statistics
| Standard deviation | 29.939435 |
|---|---|
| Coefficient of variation (CV) | 0.30055229 |
| Kurtosis | -1.263302 |
| Mean | 99.614729 |
| Median Absolute Deviation (MAD) | 27.81 |
| Skewness | 0.019132207 |
| Sum | 35894773 |
| Variance | 896.36974 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 101.84 | 4766 | 1.3% |
| 69.63 | 4280 | 1.2% |
| 81.79 | 4177 | 1.2% |
| 59.86 | 3929 | 1.1% |
| 131.81 | 3525 | 1.0% |
| 146.72 | 3435 | 1.0% |
| 126.62 | 3322 | 0.9% |
| 116.74 | 3118 | 0.9% |
| 87.07 | 3114 | 0.9% |
| 92.57 | 3089 | 0.9% |
| Other values (318) | 323581 |
| Value | Count | Frequency (%) |
| 50.79 | 1242 | |
| 51 | 1449 | |
| 51.12 | 2473 | |
| 51.16 | 322 | 0.1% |
| 51.27 | 748 | 0.2% |
| 51.47 | 781 | 0.2% |
| 52.06 | 1693 | |
| 52.42 | 228 | 0.1% |
| 52.77 | 459 | 0.1% |
| 52.97 | 1055 |
| Value | Count | Frequency (%) |
| 149.75 | 848 | 0.2% |
| 149.08 | 2104 | |
| 148.87 | 965 | 0.3% |
| 148.62 | 2014 | |
| 147.82 | 2158 | |
| 147.35 | 790 | 0.2% |
| 147.18 | 1000 | 0.3% |
| 147.17 | 1279 | 0.4% |
| 146.72 | 3435 | |
| 146.41 | 800 | 0.2% |
Interactions
Correlations
| avg_cars_at home(approx).1 | coffee_bar | cost | florist | gross_weight | low_fat | num_children_at_home | prepared_food | recyclable_package | salad_bar | store_sales(in millions) | store_sqft | total_children | unit_sales(in millions) | units_per_case | video_store | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| avg_cars_at home(approx).1 | 1.000 | 0.026 | 0.049 | 0.026 | 0.005 | 0.005 | 0.091 | 0.037 | 0.003 | 0.037 | 0.006 | 0.059 | 0.067 | 0.015 | 0.004 | 0.030 |
| coffee_bar | 0.026 | 1.000 | 0.210 | 0.554 | 0.000 | 0.002 | 0.038 | 0.481 | 0.004 | 0.481 | 0.044 | 0.570 | 0.027 | 0.128 | 0.003 | 0.544 |
| cost | 0.049 | 0.210 | 1.000 | 0.175 | -0.000 | 0.004 | -0.003 | 0.197 | 0.003 | 0.197 | -0.013 | -0.056 | -0.008 | -0.024 | 0.000 | 0.180 |
| florist | 0.026 | 0.554 | 0.175 | 1.000 | 0.000 | 0.005 | 0.037 | 0.599 | 0.005 | 0.599 | 0.051 | 0.780 | 0.029 | 0.145 | 0.004 | 0.615 |
| gross_weight | 0.005 | 0.000 | -0.000 | 0.000 | 1.000 | 0.098 | 0.000 | 0.004 | 0.098 | 0.004 | 0.042 | -0.000 | -0.001 | -0.000 | -0.015 | 0.000 |
| low_fat | 0.005 | 0.002 | 0.004 | 0.005 | 0.098 | 1.000 | 0.000 | 0.005 | 0.030 | 0.005 | 0.024 | 0.003 | 0.003 | 0.006 | 0.084 | 0.002 |
| num_children_at_home | 0.091 | 0.038 | -0.003 | 0.037 | 0.000 | 0.000 | 1.000 | 0.048 | 0.006 | 0.048 | 0.016 | 0.009 | 0.276 | 0.029 | -0.005 | 0.045 |
| prepared_food | 0.037 | 0.481 | 0.197 | 0.599 | 0.004 | 0.005 | 0.048 | 1.000 | 0.004 | 1.000 | 0.050 | 0.640 | 0.042 | 0.146 | 0.000 | 0.614 |
| recyclable_package | 0.003 | 0.004 | 0.003 | 0.005 | 0.098 | 0.030 | 0.006 | 0.004 | 1.000 | 0.004 | 0.041 | 0.004 | 0.003 | 0.002 | 0.056 | 0.004 |
| salad_bar | 0.037 | 0.481 | 0.197 | 0.599 | 0.004 | 0.005 | 0.048 | 1.000 | 0.004 | 1.000 | 0.050 | 0.640 | 0.042 | 0.146 | 0.000 | 0.614 |
| store_sales(in millions) | 0.006 | 0.044 | -0.013 | 0.051 | 0.042 | 0.024 | 0.016 | 0.050 | 0.041 | 0.050 | 1.000 | 0.021 | 0.059 | 0.449 | -0.013 | 0.032 |
| store_sqft | 0.059 | 0.570 | -0.056 | 0.780 | -0.000 | 0.003 | 0.009 | 0.640 | 0.004 | 0.640 | 0.021 | 1.000 | -0.009 | 0.034 | 0.002 | 0.695 |
| total_children | 0.067 | 0.027 | -0.008 | 0.029 | -0.001 | 0.003 | 0.276 | 0.042 | 0.003 | 0.042 | 0.059 | -0.009 | 1.000 | 0.110 | -0.000 | 0.039 |
| unit_sales(in millions) | 0.015 | 0.128 | -0.024 | 0.145 | -0.000 | 0.006 | 0.029 | 0.146 | 0.002 | 0.146 | 0.449 | 0.034 | 0.110 | 1.000 | 0.000 | 0.091 |
| units_per_case | 0.004 | 0.003 | 0.000 | 0.004 | -0.015 | 0.084 | -0.005 | 0.000 | 0.056 | 0.000 | -0.013 | 0.002 | -0.000 | 0.000 | 1.000 | 0.000 |
| video_store | 0.030 | 0.544 | 0.180 | 0.615 | 0.000 | 0.002 | 0.045 | 0.614 | 0.004 | 0.614 | 0.032 | 0.695 | 0.039 | 0.091 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| store_sales(in millions) | unit_sales(in millions) | total_children | num_children_at_home | avg_cars_at home(approx).1 | gross_weight | recyclable_package | low_fat | units_per_case | store_sqft | coffee_bar | video_store | salad_bar | prepared_food | florist | cost | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | ||||||||||||||||
| 0 | 8.61 | 3.0 | 2.0 | 2.0 | 2.0 | 10.30 | 1.0 | 0.0 | 32.0 | 36509.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 62.09 |
| 1 | 5.00 | 2.0 | 4.0 | 0.0 | 3.0 | 6.66 | 1.0 | 0.0 | 1.0 | 28206.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 121.80 |
| 2 | 14.08 | 4.0 | 0.0 | 0.0 | 3.0 | 21.30 | 1.0 | 0.0 | 26.0 | 21215.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 83.51 |
| 3 | 4.02 | 3.0 | 5.0 | 0.0 | 0.0 | 14.80 | 0.0 | 1.0 | 36.0 | 21215.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 66.78 |
| 4 | 2.13 | 3.0 | 5.0 | 0.0 | 3.0 | 17.00 | 1.0 | 1.0 | 20.0 | 27694.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 111.51 |
| 5 | 9.08 | 4.0 | 5.0 | 5.0 | 3.0 | 7.26 | 0.0 | 1.0 | 5.0 | 33858.0 | 1.0 | 0.0 | 1.0 | 1.0 | 1.0 | 142.58 |
| 6 | 4.80 | 2.0 | 1.0 | 0.0 | 2.0 | 9.58 | 0.0 | 0.0 | 6.0 | 27694.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 69.47 |
| 7 | 4.29 | 3.0 | 2.0 | 0.0 | 2.0 | 16.90 | 1.0 | 0.0 | 2.0 | 23688.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 68.84 |
| 8 | 8.55 | 3.0 | 5.0 | 0.0 | 2.0 | 13.80 | 1.0 | 0.0 | 6.0 | 38382.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 87.07 |
| 9 | 3.08 | 4.0 | 1.0 | 0.0 | 3.0 | 15.70 | 1.0 | 1.0 | 9.0 | 27694.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 80.29 |
| store_sales(in millions) | unit_sales(in millions) | total_children | num_children_at_home | avg_cars_at home(approx).1 | gross_weight | recyclable_package | low_fat | units_per_case | store_sqft | coffee_bar | video_store | salad_bar | prepared_food | florist | cost | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | ||||||||||||||||
| 360326 | 8.04 | 3.0 | 4.0 | 4.0 | 2.0 | 12.80 | 1.0 | 1.0 | 17.0 | 23688.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 67.11 |
| 360327 | 5.06 | 2.0 | 3.0 | 0.0 | 1.0 | 18.70 | 1.0 | 0.0 | 15.0 | 22478.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 107.20 |
| 360328 | 1.26 | 2.0 | 2.0 | 0.0 | 4.0 | 19.10 | 0.0 | 0.0 | 10.0 | 21215.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 91.28 |
| 360329 | 2.64 | 2.0 | 3.0 | 3.0 | 4.0 | 18.60 | 1.0 | 0.0 | 28.0 | 23688.0 | 1.0 | 0.0 | 1.0 | 1.0 | 1.0 | 85.88 |
| 360330 | 2.88 | 2.0 | 5.0 | 0.0 | 2.0 | 8.25 | 0.0 | 1.0 | 22.0 | 23593.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 119.26 |
| 360331 | 7.60 | 4.0 | 5.0 | 5.0 | 3.0 | 13.50 | 1.0 | 0.0 | 33.0 | 30268.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 133.42 |
| 360332 | 14.44 | 4.0 | 4.0 | 0.0 | 4.0 | 18.80 | 1.0 | 1.0 | 18.0 | 20319.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 81.85 |
| 360333 | 10.74 | 3.0 | 0.0 | 0.0 | 2.0 | 11.30 | 1.0 | 0.0 | 35.0 | 30584.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 87.07 |
| 360334 | 11.04 | 3.0 | 1.0 | 0.0 | 3.0 | 10.20 | 0.0 | 1.0 | 14.0 | 30584.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 146.72 |
| 360335 | 5.30 | 2.0 | 2.0 | 0.0 | 2.0 | 10.80 | 0.0 | 0.0 | 21.0 | 33858.0 | 1.0 | 0.0 | 1.0 | 1.0 | 1.0 | 122.47 |